Cost Fields

The following fields display the estimated costs, actual costs and cost differences for the Work Order. Users can complete these fields manually or let the system calculate the values using cost data from the Work Order Tasks. More information about Work Order Cost relationships

Estimated Costs

Estimated Cost fields are used establish time and cost projections for the Work Order.

Use Task Est.

When enabled, instructs the system to populate the Work Order's estimate fields with the sum of the corresponding estimate fields on all Work Order Tasks. (All estimate fields on the Work Order are read-only when this feature is enabled.)

When the Use Task Est. field is disabled, users can update the Work Order's estimate fields manually.

Est. Labor Hours

Appraises the amount of employee time required to complete the Work Order.

Est. Labor Cost

Indicates the estimated cost for employee resources required to complete the Work Order.

Est. Equipment Cost

Indicates the estimated cost of the equipment required complete the Work Order.

Est. Contractor Cost

Represents the estimated cost of contractors that must be hired to complete the Work Order.

Est. Material Cost

Indicates the projected cost of materials required to complete the Work Order.

Est. Fluid Cost

Indicates the projected cost of fluids required to complete the Work Order.

Est. Misc. Cost

Represents the projected cost of any miscellaneous items (e.g., taxes, permit fees, etc.) required to complete the Work Order.

Total Cost Est

  • Indicates the sum of the estimated costs for the entire Work Order. Automatically calculated as:

    Est Labor Cost + Est Equipment Cost + Est Contractor Cost + Est Material Cost + Est Fluid Cost + Est Misc Cost = Total Cost Est

 

Actual Costs

Actual Costfields record the actual amount of time and money required to complete the work.

Use Task Actual Costs

When enabled, instructs the system to populate the Work Order's actual cost fields with the sum of the corresponding actual cost fields on all Work Order Tasks. (All actual cost fields are read-only when enabled.)

When the Use Task Actual Costs field is disabled, users can update the Work Order's actual cost fields manually.

Actual Labor Hours

Represents the actual amount of employee hours required to complete the Work Order.

Actual Labor Cost

Represents the actual cost of employee resources used to complete the Work Order.

Actual Material Cost

Indicates the actual cost of materials used to complete the Work Order.

Actual Fluid Cost

Indicates the actual cost of fluids used to complete the Work Order.

Actual Equipment Cost

Indicates the actual cost of the equipment used to complete the Work Order.

Actual Contractor Cost

Represents the actual cost of contractor services used to complete the Work Order.

Misc. Cost

Represents the actual cost of any miscellaneous items used to complete the Work Order.

Total Cost

Indicates the actual, complete cost of the work. Automatically calculated as:

  • Actual Labor Cost + Actual Equipment Cost + Actual Contractor Cost + Actual Material Cost + Actual Fluid Cost + Misc Cost = Total Cost

Cost Difference

Cost Difference fields record the difference between an agency's estimates and the actual figures for the completed work. This data can be used to evaluate crew performance or to improve project-planning methods.

Labor Hour Diff

Displays the difference between the Est Labor Hours and the Actual Labor Hours values. Automatically calculated as:

  • Est Labor Hours - Actual Labor Hours = Labor Hour Diff

Labor Cost Diff

Displays the difference between the Est Labor Cost and the Actual Labor Cost values. Automatically calculated as:

  • Est Labor Cost - Actual Labor Cost = Labor Cost Diff

Material Cost Diff

Displays the difference between the Est Material Cost and the Actual Material Cost values. Automatically calculated as:

  • Est Material Cost - Actual Material Cost = Material Cost Diff

Fluid Cost Diff

Displays the difference between the Est Fluid Cost and the Actual Fluid Cost values. Automatically calculated as:

  • Est Fluid Cost - Actual Fluid Cost = Fluid Cost Diff

Equip Cost Diff

Displays the difference between the Est Equip Cost and the Actual Equip Cost values. Automatically calculated as:

  • Est Equip Cost - Actual Equip Cost = Equip Cost Diff

Contractor Cost Diff

Displays the difference between the Est Contractor Cost and the Actual Contractor Cost values. Automatically calculated as:

  • Est Contractor Cost - Actual Contractor Cost = Contractor Cost Diff

Misc. Cost Diff

Displays the difference between the Est Misc Cost and the Actual Misc Cost values. Automatically calculated as:

  • Est Misc Cost - Actual Misc Cost = Misc Cost Diff

Total Cost Diff

Displays the difference between the Est Total Cost and the Actual Total Cost values. Automatically calculated as:

  • Est Total Cost - Actual Total Cost = Total Cost Diff

Other Cost Fields

Quantity

Indicates the amount of items worked on within the Work Order. The user can enter the quantity manually or allow the system to calculate the number based on the type of asset:

  • Manual - Users can manually complete this field if assets are not listed on the Work Order or if they want to adjust the quantity.

    • Check the Quantity Lock box to ensure they system doesn't overwrite the manual value.
  • Count - Often used when the Work Order addresses discreet assets that are individual units. This method assumes that the work performed on each asset is the same.
    Example:  

    Painting Fire Hydrants - The crew painted 5 fire hydrants.

  • Sum - Often used when the Work Order addresses assets that vary widely in size. A larger asset will take much longer to work on than a smaller asset, therefore, the work done on each asset will vary depending on the asset. This adds together some metric about each asset worked on.

    Example:  Cleaning Sewer Pipes - They cleaned 500 linear feet of sewer pipe.

More information about how to configure Quantity Calculations

Quantity Lock

Locks the Quantity field to prevent the system from calculating the value. This feature enables users to enter a quantity manually, without the system overwriting it.

Unit of Measure

Indicates the unit in which the Quantity is measured.

  • Lucity populates this field using the default value from the Category Setup record associated with the Category identified on the Work Order.
  • If the Category Setup record does not set this value, the system attempts to determine the value using data from the Task Setup record associated with the Work Order's Main Task.

Unit Cost

Calculates the cost of working on each unit of asset.

Automatically calculated as: Total Cost/Quantity = Unit Cost

Note:  Depending on how the quantity is measured, this value could represent the per asset cost (e.g., $100 per asset) or the per unit of asset cost (e.g., $100 per linear foot).

WO Hours

Gives agencies who do not use Work Order Tasks a simple way to enter the number of hours spent completing this Work Order. This field is not included in any calculations.